package com.ruoyi.welcome.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface DocWelContractNumMapper {

    /**
     * 查询状态为1的合同数量
     * @return 数量统计结果
     */
    @Select("SELECT COUNT(*) AS contract_count FROM doc_contract WHERE contract_state = 1")
    Integer selectContractCountByState1();
}
